A Database Design and Development Case: Elk County Pediatric Medical Center

This case provides a real-world end-of-semester project-oriented case study for students enrolled in an introductory database management course. The case consists of a business scenario to provide background information on the need for the application and some of the unique operating characteristics of the Elk County Pediatric Medical Center. In addition, narrative information regarding the functional requirements of the medical center is included along with sample data: parents, patients, services performed, diagnosis codes, insurance carriers, and patient history. The case provides sufficient information to design a moderately complex database for the medical clinic. The functional requirements will force students to resolve numerous many-to-many relationships. In addition, several entities have compound unique identifiers resulting in tables with composite primary and foreign keys. The case provides sufficient real-world data to operationalize the database design into a physical database, populate it with data, and then write a series of queries that satisfy the stated reporting requirements of the medical center. The queries vary considerably in terms of complexity, from simple straightforward queries to others that are quite complex and require multiple sub-queries. Several queries are dependent upon parameters entered at runtime. Some queries all students should be able to answer, while others require critical thinking skills to solve. The case was written so that creation of the physical database and queries were not dependent on the student’s database management software. Teaching notes containing suggested instructions, a possible entity-relationship model, the resulting physical database, and the solution to the queries are also provided

An eCommerce Development Case: Your Company\u27s eCommerce Web Site

This case provides a real-world semester long project-oriented case study for students enrolled in an electronic commerce course that has a significant development component. The case provides the technical framework in the form of functional requirements for students to design and build a fully functional transaction processing e-commerce Web site over the course of a semester based on the company, products and/or services, content, and graphic images they choose. The case is divided into three assignments. The first assignment is a basic e-commerce Web site that emphasizes site layout, navigation, text formatting, inserting graphics, and the content necessary to market products and services online. Additional complexity is added in the second assignment, an enhanced e-commerce Web site. In this assignment students will create their own graphics images, menus, and image maps, use JavaScript to create image rollovers and image swaps, dynamically generate Web pages based on the contents of a database, and use a form to send data to an email address. The third assignment is a full-fledged transaction processing e-commerce Web site with a virtual shopping cart and checkout processing procedures. The case can to be used in a course where the students have little or no prior programming or relational database experience. The case was written so that the creation of the student\u27s e-commerce Web site is not dependent upon the student\u27s e-commerce development software, graphics tool set, Web server, Web programming environment, or relational database management system. Teaching notes containing suggested instructions, possible development environments, Web server configurations hints, individual assignment objectives, and a sample solution to the final assignment are provided

Instructional Technology in Business Education: An Examination of Online Learning Styles

Management education has rapidly adapted to recent technological advances with initiatives ranging from Web-based degrees conferred by online schools to hybrid courses offered on traditional campuses. Despite the substantial growth in these programs, however, the field’s understanding of the effects of these initiatives is rela- tively limited as only a few management education researchers have empirically investigated the actual use of in- structional technologies. The present study adds to the developing empirical literature by examining Web log server data generated by undergraduate students enrolled in a Management Information Systems course where an online Learning Management System (LMS) was used to complement a traditional classroom environment. We adopt a comprehensive model of student learning to guide the pursuit of two research questions: 1) How do students use online instructional technologies? and 2) What effect does such usage have on student learning? Our findings indi- cate that distinct usage patterns are reflected in how students actually use instructional technologies and that there are gender differences in these patterns. These findings illustrate the potential role of online learning styles in the consideration of the effects of instructional technologies on student learning

An Exploratory Study Of Student Satisfaction With University Web Page Design

This exploratory study evaluates the satisfaction of students with a web-based information system at a medium-sized regional university. The analysis provides a process for simplifying data interpretation in captured student user feedback. Findings indicate that student classifications, as measured by demographic and other factors, determine satisfaction levels towards various web sources of information. Differences in satisfaction levels across student groups based on gender, age, minority status, employment, and current course load were found. Implications for university web designers and university administrators are considered and discussed

An Exploratory Study Of Student Satisfaction With University Web Page Design

This exploratory study evaluates the satisfaction of students with a web-based information system at a medium-sized regional university. The analysis provides a process for simplifying data interpretation in captured student user feedback. Findings indicate that student classifications, as measured by demographic and other factors, determine satisfaction levels towards various web sources of information. Differences in satisfaction levels across student groups based on gender, age, minority status, employment, and current course load were found. Implications for university web designers and university administrators are considered and discussed